ByteDance Data Platform: ClickHouse-based Complex Query Implementation and Optimization